1 2 3 4 5 6 7
| DROP PROCEDURE IF EXISTS pro_test;
create procedure pro_test(in val VARCHAR(50) ,out rtn int) begin declare err INT default 0;
declare exit handler for sqlexception ROLLBACK ;
|
1 2 3 4 5 6 7 8 9 10
| insert into test_user values(NULL,1,'啊是大三的');
set err =last_insert_id(); insert into test_user VALUES(NULL,val,err);
commit;
set rtn=1; end;
|
1 2 3 4 5
| $name = '成都市'; $stmt = $db->prepare("CALL pro_test(?,@sp_result);"); $stmt->bindParam(1, $name); $stmt->execute (); $outputArray = $db->query("select @sp_result")->fetch(PDO::FETCH_ASSOC);
|
1
| print_r($outputArray["@sp_result"]);
|
转载自:http://blog.csdn.net/auspi12341/article/details/17167069